package com.dingding.service.core.special.sql;

/**
 * 
 * @ClassName: SpeicalDriverSQL 
 * @Description: 专车司机SQL类 
 * @author YHQ
 * @date 2016年12月5日 下午1:54:38
 * @since V2.5.7
 * 
 */
public class SpecialDriverSQL {

	/**
	 * @author YHQ
	 * @Description: 根据用户手机号获取用户登录信息
	 */
	public static final String GET_SPEICAL_USER_LOGIN_BY_TELPHONE = "SELECT suid, aliasId, rongCloudToken, userName, depositPwd, userStatus, userRole, isDeposit, clientType, loginCity, clientVersion, imei, lastLoginTime, createTime, depositNumber FROM specialuserlogin WHERE userName = ?";
	
	/**
	 * @author hufan
	 * @Description: 根据用户id获取用户登录信息
	 */
	public static final String GET_SPEICAL_USER_LOGIN_BY_USERID = "SELECT suid, aliasId, rongCloudToken, userName, depositPwd, userStatus, userRole, isDeposit, clientType, loginCity, clientVersion, imei, lastLoginTime, createTime, depositNumber FROM specialuserlogin WHERE suid = ?";
	
}
